package com.zhx.mybatislog.user.dao;

import com.zhx.mybatislog.user.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

/**
 * <p>
 * 用户表 Mapper 接口
 * </p>
 *
 * @author YangJinChuan
 * @since 2021-04-30
 */
@Mapper
public interface SysUserMapper {
    @Update("update sys_user set password=#{password} ,account=#{account} ,uname=#{uname} where id=#{id}")
    int updateUser(User user);
    @Update("update sys_user set password='1111111' where id=#{id}")
    int updateUser1(Integer id);

    @Update("update sys_user set password='1111111' where id=18001")
    int  updateUser2(Integer id);

    @Update("select * from sys_user where id=18001")
    int  updateUser3(String password, Integer id);
}
